package com.conversationboard.model.yellowcardlog;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import com.conversationboard.database.Queries;

public class YellowCardLog {

	public static void write(Connection connection, String loginId, String reason, int boardId, int threadId, int messageId, String post, String modLoginId) throws SQLException {

		PreparedStatement statement = connection.prepareStatement(Queries.RECORD_YELLOWCARD_LOG);
		statement.setString(1, loginId);
		statement.setString(2, reason);
		statement.setInt(3, boardId);
		statement.setInt(4, threadId);
		statement.setInt(5, messageId);
		statement.setString(6, post);
		statement.setString(7, modLoginId);

		statement.executeUpdate();
		statement.close();

	}

}
